from sqlalchemy import Column, String, Integer,DateTime
from DataBase.DataBaseConnect import DBConnect

class DeviceInfo(DBConnect.Base):
    #Base作为被继承的类
    __tablename__ = 'device_info'
    id = Column(Integer,primary_key=True)
    device_desc = Column(String(64),nullable=False,index=True)
    platform_name = Column(String(20),nullable=False,index=True)
    platform_version = Column(String(20),nullable=False,index=True)
    device_name = Column(String(48),nullable=False,index=True)
    udid = Column(String(48),nullable=False,index=True)
    del_flg = Column(String(1),nullable=False,index=True)
    create_time = Column(DateTime(),nullable=False,index=True)
    update_time = Column(DateTime(),nullable=False,index=True)
    ip = Column(String(20), nullable=False, index=True)